Stock items

You'll need to create a record for each stock item that you want to keep track of in Sage 200. You can do this for physical items that you keep in stock and also for items that you order direct from your suppliers, services, and time or labour you want include on customer invoices.

What's in a stock item

Each stock item has a unique code and name. We recommend that you consider the code that you use for your stock items carefully. By default the code is used on sales invoices and orders and purchase orders but you can choose to use or a longer item description or the suppliers part number / reference if you wish.

Each stock item has default settings that are used each time the item is bought or sold. Some of these are inherited from the product group and some are set on each item.

Decisions to make about your stock items

You enter information about your stock items across several tabs. You can't save a stock item unless it has a Code, Name, Product Group and Location. Any defaults that are inherited from the product group are entered automatically. Everything else is optional.

Location

This is important as the stock location is used by Sage 200 throughout the sales and purchase process.

You have to choose a location for all your stock items, even if they're Service / Labour type items. If you don't want to record your stock items in different locations, you can use the default HOME warehouse we've already set up for you.

If you do want to record stock in various locations, you have set up your warehouses first. Once you've set up your warehouses, you can use Sage 200 to keep track of the amount of stock you have in each warehouse and bin (if using).

Tip: You can't save a stock item without location (warehouse). If you don't know the location you can still save the item but Sage 200 makes it Inactive. You'll have to enter a location and make the item Active before you can use it.

Default VAT rate

You can set a VAT rate to be used by default each time the item is entered on a sales invoice, sales order or purchase order. If you don't change it here, the standard VAT rate will be used automatically.

Item status

When a stock items is marked as Inactive, it doesn't appear on your stock item lists, so it can't be included on sales invoices, sales orders or purchase orders. It's a good idea to use this for stock items that you don't sell any more or don't want to sell for a temporary period, as it prevents them from being added to invoices and orders by mistake.

The status of all items (Active and Inactive) can be changed using the Amend stock item details screen.

Tip: If you can't find an item in a list, it's a good idea to check its status. Remember, if you save a stock item without a location, Sage 200 makes it Inactive automatically.

You cannot make a stock item Inactive when the item is:

  • On a Live purchase order or purchase return.
  • On a Live sales order or sales return.
  • Allocated.
  • Part of a BOM.

  • A cross-selling item for another stock item.

Item description or Part No

When stock items are added to invoices and orders, the Code and Name that you've given to the item is used on printed documents that are sent to customers and suppliers. Depending on the coding system you've used, there may be occasions where this is not sufficient.

Sage 200 has three alternative options that you can use:

Stock take cycle

Use this to specify how often (in days) you want to do a stock take for this item. You then use the Stocktake required report to see stock items due for stock take. The report lists stock items, their stock take cycle and the date of the last stock take for each item.

Is it assembled from other stock items (BOM)

If the stock item is a finished item, i.e. made up from other stock items, you can create a Bill of Materials (BOM) for it. This is a record of the items required to assemble it. You can also check whether you have enough items in stock to assemble the item and record when item has been built so your stock levels are adjusted.

If you want to create a Bill of Materials for this item, make sure you select Built Item on the Details tab.

Bar codes

If you use bar codes for your stock items, you record the bar code on the stock record (Details tab) to make stock identification easier.

Once recorded, you can print bar code labels for your stock items from Sage 200 (Stock Control > Reports > Catalogue > Stock Bar code Labels). Bar codes are printed in Code 39 format. If you use a different format you can change this in Report Designer.

Analysis codes

For your stock items, you can use analysis codes as a way of classifying your stock items so that you distinguish between them.

For example, you could use analysis codes to record the commodity code of a stock item. Although the stock item record has a commodity code option, this is specifically designed to be used for the commodity code used on an Intrastat declarations. Analysis codes are a good way of adding other commodity codes such as the ones used for export documents.

Another example where you use the codes to distinguish how they are stored. If you keep some items in ambient storage and others in a cold store, you use analysis codes to distinguish between these items. You could then run reports to make sure that you cold store items are located in your cold store warehouse.

Nominal accounts

You set the nominal accounts that you want to use by default for the stock item here. When you create a stock item, these are inherited from the product group. You can override these on invoices and orders but entering a default here helps to make sure that transactions are posted correctly.

You specify two default nominal accounts:

  • Stock

    Used to record the value of the stock you have bought. By default, Sage 200 uses the Stock account on the Balance Sheet, specified in the Default Nominal Accounts.

  • Revenue

    Used to record the value of stock sold. This would normally be an Income account on the Profit and Loss. By default Sage 200 uses the Sales account specified in the Default Nominal Accounts.

How the nominal accounts are used

Suppliers

Use this to record the suppliers of this stock item.

You can specify a preferred supplier for an item. By default this is the first supplier on the list. The preferred supplier details are suggested when you create purchase orders using Generate Orders.

When you set up a supplier for the stock item, this lets you:

  • Create purchase orders to directly fulfil a sales order (back to back orders).

  • Set Re-order levels. This allows you to use the Generate Orders option to automatically create purchase orders when the stock level is below the re-order level.

  • Use the Suppliers stock code on printed purchase orders rather than the item code.

    Once entered, this overrides the Code and/or Part No and is printed on purchase orders for this supplier.

  • See a detailed order history for the item.

  • Specify a List price and choose the price to use when the item is bought from the supplier. Once set, this price overrides the cost price on the item.

    You do this by setting the Price Source. This can be a List price or the last price you paid (Last buying Price).

  • Specify the landed costs to use when the item is bought from this supplier.

    Once entered this overrides the default landed costs entered on the stock item.

  • Choose the Country of Origin for the item for your Intrastat declaration.

Alternatives

Use this if you want to suggest an alternative item when this item is out of stock. When the person sees the item is out of stock, they can choose from one of the alternatives you've set up here.

You don't have to set up alternatives, and can just leave this blank if you don't want to use it.

If you set up alternatives, you'll be able to select one of the alternatives when you add a standard stock item to a sales order, quotation, or purchase order. If there's more than one alternative, you can set one as the preferred alternative.

Note: Alternatives can't be specified on Invoices (from Invoicing).

Your alternative items must be of the same type, i.e. you can't use a Service/ Labour type item as an alternative for a Stock type item.

Cross-selling

Set up cross-selling items if you want to display complimentary items when you add an item to a sales order. For example, if you sell a printer, you might want to show print cartridges or cables for that printer.

  • To add cross-selling items for a stock item, amend the stock item and use the Cross-selling tab.

    See Cross-selling stock items.

Attachments and memos

You can link files and documents with a stock item record. This could be a picture or image of the stock item or any other related document.

You can also add internal notes about a stock item in the form of Memos. These can't be printed on documents. When memos are not no longer valid you either delete them or mark them as Inactive, in case you want to keep a record of the text.

Comments

These can be printed on picking lists and despatch notes. Once entered here, the comments are used by default on all picking lists or despatch notes for the stock item.

You can change the comments on individual invoices and orders if you need to.

Landed costs

You can set the default landed costs to be used for this stock item here. If you don't change them, the defaults entered on the product group are used. Choose whether to charge as a set amount or as a percentage. This can be changed on purchase orders as required.

If you change this after you've entered purchase orders for this item, you existing orders won't be affected.

Opening balances

If you're moving from another system, and you want Sage 200 to keep track of your stock items and their value, then you'll need to enter an opening balance for each item. This updates the quantity in stock and updates your buying price (used to value your stock). You enter the balance for each warehouse and bin (if the item's stored in more than one).

You don't have to do this for all stock items in one go, although you can only enter the a balance for each warehouse and bin, once. Doing this doesn't post any values to your nominal accounts, as this will have been included in your opening trial balance, if you've entered one.

If you've already got a list of your current stock levels, on an Excel spreadsheet for example, you can import your opening balances via a CSV file.

Are you ready to perform these actions?

Have you completed the necessary set up so that you can create your stock items? Before you can create stock items, you need to

What do you want to do

What's next

Set up stock fulfilment methods

Create a Bill of Materials

Move and allocate stock

Enter sales orders

Enter purchase orders